HELOC Data Profiling Report- v2

Dataset statistics

Number of variables	24
Number of observations	10459
Missing cells	26167
Missing cells (%)	10.4%
Duplicate rows	3
Duplicate rows (%)	< 0.1%
Total size in memory	2.4 MiB
Average record size in memory	236.5 B

Variable types

Categorical	1
Numeric	23

Alerts

Dataset has 3 (< 0.1%) duplicate rows	Duplicates
`AverageMInFile` is highly overall correlated with `MSinceOldestTradeOpen`	High correlation
`ExternalRiskEstimate` is highly overall correlated with `MSinceMostRecentDelq` and 5 other fields	High correlation
`MSinceMostRecentDelq` is highly overall correlated with `ExternalRiskEstimate` and 1 other fields	High correlation
`MSinceMostRecentTradeOpen` is highly overall correlated with `NumTradesOpeninLast12M`	High correlation
`MSinceOldestTradeOpen` is highly overall correlated with `AverageMInFile`	High correlation
`MaxDelq/PublicRecLast12M` is highly overall correlated with `ExternalRiskEstimate` and 4 other fields	High correlation
`MaxDelqEver` is highly overall correlated with `ExternalRiskEstimate` and 4 other fields	High correlation
`NetFractionRevolvingBurden` is highly overall correlated with `ExternalRiskEstimate` and 2 other fields	High correlation
`NumBank/NatlTradesWHighUtilization` is highly overall correlated with `ExternalRiskEstimate` and 2 other fields	High correlation
`NumInqLast6M` is highly overall correlated with `NumInqLast6Mexcl7days`	High correlation
`NumInqLast6Mexcl7days` is highly overall correlated with `NumInqLast6M`	High correlation
`NumRevolvingTradesWBalance` is highly overall correlated with `NumBank/NatlTradesWHighUtilization`	High correlation
`NumSatisfactoryTrades` is highly overall correlated with `NumTotalTrades`	High correlation
`NumTotalTrades` is highly overall correlated with `NumSatisfactoryTrades`	High correlation
`NumTrades60Ever/DerogPubRec` is highly overall correlated with `MaxDelq/PublicRecLast12M` and 3 other fields	High correlation
`NumTrades90Ever/DerogPubRec` is highly overall correlated with `MaxDelqEver` and 1 other fields	High correlation
`NumTradesOpeninLast12M` is highly overall correlated with `MSinceMostRecentTradeOpen`	High correlation
`PercentTradesNeverDelq` is highly overall correlated with `ExternalRiskEstimate` and 3 other fields	High correlation
`PercentTradesWBalance` is highly overall correlated with `NetFractionRevolvingBurden`	High correlation
`ExternalRiskEstimate` has 598 (5.7%) missing values	Missing
`MSinceOldestTradeOpen` has 827 (7.9%) missing values	Missing
`MSinceMostRecentTradeOpen` has 588 (5.6%) missing values	Missing
`AverageMInFile` has 588 (5.6%) missing values	Missing
`NumSatisfactoryTrades` has 588 (5.6%) missing values	Missing
`NumTrades60Ever/DerogPubRec` has 588 (5.6%) missing values	Missing
`NumTrades90Ever/DerogPubRec` has 588 (5.6%) missing values	Missing
`PercentTradesNeverDelq` has 588 (5.6%) missing values	Missing
`MSinceMostRecentDelq` has 5428 (51.9%) missing values	Missing
`MaxDelq/PublicRecLast12M` has 588 (5.6%) missing values	Missing
`MaxDelqEver` has 588 (5.6%) missing values	Missing
`NumTotalTrades` has 588 (5.6%) missing values	Missing
`NumTradesOpeninLast12M` has 588 (5.6%) missing values	Missing
`PercentInstallTrades` has 588 (5.6%) missing values	Missing
`MSinceMostRecentInqexcl7days` has 2919 (27.9%) missing values	Missing
`NumInqLast6M` has 588 (5.6%) missing values	Missing
`NumInqLast6Mexcl7days` has 588 (5.6%) missing values	Missing
`NetFractionRevolvingBurden` has 774 (7.4%) missing values	Missing
`NetFractionInstallBurden` has 4007 (38.3%) missing values	Missing
`NumRevolvingTradesWBalance` has 744 (7.1%) missing values	Missing
`NumInstallTradesWBalance` has 1449 (13.9%) missing values	Missing
`NumBank/NatlTradesWHighUtilization` has 1171 (11.2%) missing values	Missing
`PercentTradesWBalance` has 606 (5.8%) missing values	Missing
`MSinceMostRecentTradeOpen` has 105 (1.0%) zeros	Zeros
`NumTrades60Ever/DerogPubRec` has 6802 (65.0%) zeros	Zeros
`NumTrades90Ever/DerogPubRec` has 7639 (73.0%) zeros	Zeros
`MaxDelq/PublicRecLast12M` has 336 (3.2%) zeros	Zeros
`NumTotalTrades` has 133 (1.3%) zeros	Zeros
`NumTradesOpeninLast12M` has 2508 (24.0%) zeros	Zeros
`PercentInstallTrades` has 193 (1.8%) zeros	Zeros
`MSinceMostRecentInqexcl7days` has 4582 (43.8%) zeros	Zeros
`NumInqLast6M` has 3924 (37.5%) zeros	Zeros
`NumInqLast6Mexcl7days` has 4078 (39.0%) zeros	Zeros
`NetFractionRevolvingBurden` has 608 (5.8%) zeros	Zeros
`NumRevolvingTradesWBalance` has 304 (2.9%) zeros	Zeros
`NumBank/NatlTradesWHighUtilization` has 4308 (41.2%) zeros	Zeros

Reproduction

Analysis started	2024-05-31 08:55:38.888203
Analysis finished	2024-05-31 08:57:32.566859
Duration	1 minute and 53.68 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

RiskPerformance
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	536.1 KiB

Bad	5459
Good	5000

Length

Max length	4
Median length	3
Mean length	3.4780572
Min length	3

Characters and Unicode

Total characters	36377
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bad
2nd row	Bad
3rd row	Bad
4th row	Bad
5th row	Bad

Common Values

Value	Count	Frequency (%)
Bad	5459	52.2%
Good	5000	47.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bad	5459	52.2%
good	5000	47.8%

Most occurring characters

Value	Count	Frequency (%)
d	10459	28.8%
o	10000	27.5%
B	5459	15.0%
a	5459	15.0%
G	5000	13.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	36377	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	10459	28.8%
o	10000	27.5%
B	5459	15.0%
a	5459	15.0%
G	5000	13.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	36377	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	10459	28.8%
o	10000	27.5%
B	5459	15.0%
a	5459	15.0%
G	5000	13.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	36377	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	10459	28.8%
o	10000	27.5%
B	5459	15.0%
a	5459	15.0%
G	5000	13.7%

ExternalRiskEstimate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	60
Distinct (%)	0.6%
Missing	598
Missing (%)	5.7%
Infinite	0
Infinite (%)	0.0%
Mean	72.06044

Minimum	33
Maximum	94
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	33
5-th percentile	57
Q1	64
median	72
Q3	80
95-th percentile	88
Maximum	94
Range	61
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.8717947
Coefficient of variation (CV)	0.13699326
Kurtosis	-0.76136203
Mean	72.06044
Median Absolute Deviation (MAD)	8
Skewness	0.0013558785
Sum	710588
Variance	97.45233
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65	386	3.7%
66	376	3.6%
68	372	3.6%
73	369	3.5%
72	367	3.5%
70	350	3.3%
63	338	3.2%
75	331	3.2%
69	316	3.0%
80	302	2.9%
Other values (50)	6354	60.8%
(Missing)	598	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
33	1	< 0.1%
34	1	< 0.1%
36	2	< 0.1%
37	1	< 0.1%
39	1	< 0.1%
40	2	< 0.1%
41	1	< 0.1%
42	2	< 0.1%
43	5	< 0.1%
44	4	< 0.1%

Value	Count	Frequency (%)
94	1	< 0.1%
93	16	0.2%
92	34	0.3%
91	103	1.0%
90	100	1.0%
89	161	1.5%
88	201	1.9%
87	190	1.8%
86	254	2.4%
85	223	2.1%

MSinceOldestTradeOpen
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	524
Distinct (%)	5.4%
Missing	827
Missing (%)	7.9%
Infinite	0
Infinite (%)	0.0%
Mean	200.7691

Minimum	2
Maximum	803
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	2
5-th percentile	59
Q1	135
median	186
Q3	257
95-th percentile	388
Maximum	803
Range	801
Interquartile range (IQR)	122

Descriptive statistics

Standard deviation	97.946081
Coefficient of variation (CV)	0.48785435
Kurtosis	0.61545143
Mean	200.7691
Median Absolute Deviation (MAD)	59
Skewness	0.71147894
Sum	1933808
Variance	9593.4348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
132	67	0.6%
178	67	0.6%
150	62	0.6%
176	62	0.6%
165	61	0.6%
183	58	0.6%
158	57	0.5%
206	57	0.5%
162	57	0.5%
172	57	0.5%
Other values (514)	9027	86.3%
(Missing)	827	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	3	< 0.1%
7	3	< 0.1%
8	5	< 0.1%
9	2	< 0.1%
10	6	0.1%
11	6	0.1%
12	7	0.1%

Value	Count	Frequency (%)
803	1	< 0.1%
789	1	< 0.1%
604	1	< 0.1%
603	1	< 0.1%
598	1	< 0.1%
590	1	< 0.1%
589	2	< 0.1%
586	1	< 0.1%
584	1	< 0.1%
566	1	< 0.1%

MSinceMostRecentTradeOpen
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	111
Distinct (%)	1.1%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	9.5884915

Minimum	0
Maximum	383
Zeros	105
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	6
Q3	12
95-th percentile	29
Maximum	383
Range	383
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	12.963398
Coefficient of variation (CV)	1.3519747
Kurtosis	111.4665
Mean	9.5884915
Median Absolute Deviation (MAD)	4
Skewness	7.0894028
Sum	94648
Variance	168.04969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1161	11.1%
3	1015	9.7%
4	885	8.5%
5	754	7.2%
1	733	7.0%
6	660	6.3%
7	575	5.5%
8	463	4.4%
9	414	4.0%
10	309	3.0%
Other values (101)	2902	27.7%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	105	1.0%
1	733	7.0%
2	1161	11.1%
3	1015	9.7%
4	885	8.5%
5	754	7.2%
6	660	6.3%
7	575	5.5%
8	463	4.4%
9	414	4.0%

Value	Count	Frequency (%)
383	1	< 0.1%
227	1	< 0.1%
207	1	< 0.1%
184	1	< 0.1%
178	1	< 0.1%
163	1	< 0.1%
159	1	< 0.1%
156	2	< 0.1%
152	1	< 0.1%
145	2	< 0.1%

AverageMInFile
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	236
Distinct (%)	2.4%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	78.778138

Minimum	4
Maximum	383
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	4
5-th percentile	28
Q1	57
median	76
Q3	97
95-th percentile	139
Maximum	383
Range	379
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	34.066063
Coefficient of variation (CV)	0.43243042
Kurtosis	2.671527
Mean	78.778138
Median Absolute Deviation (MAD)	20
Skewness	0.92056167
Sum	777619
Variance	1160.4967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
71	154	1.5%
79	154	1.5%
74	151	1.4%
68	148	1.4%
80	147	1.4%
75	145	1.4%
84	144	1.4%
63	141	1.3%
70	141	1.3%
81	140	1.3%
Other values (226)	8406	80.4%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	4	< 0.1%
5	6	0.1%
6	4	< 0.1%
7	9	0.1%
8	12	0.1%
9	15	0.1%
10	12	0.1%
11	12	0.1%
12	14	0.1%
13	20	0.2%

Value	Count	Frequency (%)
383	1	< 0.1%
322	1	< 0.1%
275	1	< 0.1%
273	1	< 0.1%
263	1	< 0.1%
258	1	< 0.1%
257	1	< 0.1%
256	1	< 0.1%
252	1	< 0.1%
249	1	< 0.1%

NumSatisfactoryTrades
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	73
Distinct (%)	0.7%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	21.121467

Minimum	0
Maximum	79
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	13
median	20
Q3	28
95-th percentile	42
Maximum	79
Range	79
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.321396
Coefficient of variation (CV)	0.5360137
Kurtosis	0.85558801
Mean	21.121467
Median Absolute Deviation (MAD)	7
Skewness	0.80211911
Sum	208490
Variance	128.174
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	386	3.7%
15	384	3.7%
16	376	3.6%
22	369	3.5%
19	366	3.5%
13	364	3.5%
14	347	3.3%
21	346	3.3%
20	343	3.3%
17	337	3.2%
Other values (63)	6253	59.8%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	49	0.5%
2	92	0.9%
3	102	1.0%
4	138	1.3%
5	154	1.5%
6	186	1.8%
7	216	2.1%
8	219	2.1%
9	257	2.5%

Value	Count	Frequency (%)
79	1	< 0.1%
78	1	< 0.1%
75	1	< 0.1%
74	2	< 0.1%
70	2	< 0.1%
67	3	< 0.1%
66	2	< 0.1%
65	4	< 0.1%
64	6	0.1%
63	5	< 0.1%

NumTrades60Ever/DerogPubRec
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	18
Distinct (%)	0.2%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.58140006

Minimum	0
Maximum	19
Zeros	6802
Zeros (%)	65.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	19
Range	19
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.2387833
Coefficient of variation (CV)	2.13069
Kurtosis	28.60502
Mean	0.58140006
Median Absolute Deviation (MAD)	0
Skewness	4.1698288
Sum	5739
Variance	1.5345841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	6802	65.0%
1	1802	17.2%
2	692	6.6%
3	246	2.4%
4	148	1.4%
5	73	0.7%
6	37	0.4%
7	30	0.3%
8	11	0.1%
9	8	0.1%
Other values (8)	22	0.2%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6802	65.0%
1	1802	17.2%
2	692	6.6%
3	246	2.4%
4	148	1.4%
5	73	0.7%
6	37	0.4%
7	30	0.3%
8	11	0.1%
9	8	0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	2	< 0.1%
12	3	< 0.1%
11	4	< 0.1%
10	8	0.1%
9	8	0.1%
8	11	0.1%

NumTrades90Ever/DerogPubRec
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.38476345

Minimum	0
Maximum	19
Zeros	7639
Zeros (%)	73.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.99322265
Coefficient of variation (CV)	2.5813851
Kurtosis	51.350763
Mean	0.38476345
Median Absolute Deviation (MAD)	0
Skewness	5.4547851
Sum	3798
Variance	0.98649123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	7639	73.0%
1	1436	13.7%
2	488	4.7%
3	129	1.2%
4	83	0.8%
5	38	0.4%
6	18	0.2%
7	16	0.2%
9	8	0.1%
10	5	< 0.1%
Other values (6)	11	0.1%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7639	73.0%
1	1436	13.7%
2	488	4.7%
3	129	1.2%
4	83	0.8%
5	38	0.4%
6	18	0.2%
7	16	0.2%
8	3	< 0.1%
9	8	0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
16	2	< 0.1%
14	1	< 0.1%
12	2	< 0.1%
11	2	< 0.1%
10	5	< 0.1%
9	8	0.1%
8	3	< 0.1%
7	16	0.2%
6	18	0.2%

PercentTradesNeverDelq
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	71
Distinct (%)	0.7%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	92.359943

Minimum	0
Maximum	100
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	68
Q1	89
median	97
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	11.772876
Coefficient of variation (CV)	0.12746734
Kurtosis	7.9023322
Mean	92.359943
Median Absolute Deviation (MAD)	3
Skewness	-2.4309447
Sum	911685
Variance	138.60062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	4607	44.0%
96	414	4.0%
97	389	3.7%
95	379	3.6%
94	351	3.4%
93	304	2.9%
92	292	2.8%
88	244	2.3%
90	218	2.1%
89	205	2.0%
Other values (61)	2468	23.6%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.1%
11	1	< 0.1%
20	4	< 0.1%
22	1	< 0.1%
25	6	0.1%
27	1	< 0.1%
28	1	< 0.1%
29	4	< 0.1%
30	4	< 0.1%
31	3	< 0.1%

Value	Count	Frequency (%)
100	4607	44.0%
99	6	0.1%
98	173	1.7%
97	389	3.7%
96	414	4.0%
95	379	3.6%
94	351	3.4%
93	304	2.9%
92	292	2.8%
91	188	1.8%

MSinceMostRecentDelq
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	84
Distinct (%)	1.7%
Missing	5428
Missing (%)	51.9%
Infinite	0
Infinite (%)	0.0%
Mean	21.879547

Minimum	0
Maximum	83
Zeros	102
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	15
Q3	34
95-th percentile	67
Maximum	83
Range	83
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	20.808514
Coefficient of variation (CV)	0.95104865
Kurtosis	0.16689998
Mean	21.879547
Median Absolute Deviation (MAD)	12
Skewness	1.0662159
Sum	110076
Variance	432.99424
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	307	2.9%
2	294	2.8%
3	253	2.4%
4	228	2.2%
5	178	1.7%
6	170	1.6%
8	146	1.4%
7	140	1.3%
10	125	1.2%
9	123	1.2%
Other values (74)	3067	29.3%
(Missing)	5428	51.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	102	1.0%
1	307	2.9%
2	294	2.8%
3	253	2.4%
4	228	2.2%
5	178	1.7%
6	170	1.6%
7	140	1.3%
8	146	1.4%
9	123	1.2%

Value	Count	Frequency (%)
83	1	< 0.1%
82	1	< 0.1%
81	14	0.1%
80	15	0.1%
79	19	0.2%
78	16	0.2%
77	14	0.1%
76	15	0.1%
75	9	0.1%
74	12	0.1%

MaxDelq/PublicRecLast12M
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	9
Distinct (%)	0.1%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	5.7579779

Minimum	0
Maximum	9
Zeros	336
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	5
median	6
Q3	7
95-th percentile	7
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6445177
Coefficient of variation (CV)	0.28560682
Kurtosis	3.1912751
Mean	5.7579779
Median Absolute Deviation (MAD)	1
Skewness	-1.77708
Sum	56837
Variance	2.7044386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
7	4223	40.4%
6	3127	29.9%
4	1612	15.4%
0	336	3.2%
5	236	2.3%
3	224	2.1%
1	54	0.5%
2	53	0.5%
9	6	0.1%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	336	3.2%
1	54	0.5%
2	53	0.5%
3	224	2.1%
4	1612	15.4%
5	236	2.3%
6	3127	29.9%
7	4223	40.4%
9	6	0.1%

Value	Count	Frequency (%)
9	6	0.1%
7	4223	40.4%
6	3127	29.9%
5	236	2.3%
4	1612	15.4%
3	224	2.1%
2	53	0.5%
1	54	0.5%
0	336	3.2%

MaxDelqEver
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7
Distinct (%)	0.1%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	6.3745315

Minimum	2
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	6
median	6
Q3	8
95-th percentile	8
Maximum	8
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.8491861
Coefficient of variation (CV)	0.29008972
Kurtosis	0.088507949
Mean	6.3745315
Median Absolute Deviation (MAD)	2
Skewness	-0.98210295
Sum	62923
Variance	3.4194891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
8	4532	43.3%
6	2868	27.4%
5	968	9.3%
2	739	7.1%
4	321	3.1%
3	311	3.0%
7	132	1.3%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	739	7.1%
3	311	3.0%
4	321	3.1%
5	968	9.3%
6	2868	27.4%
7	132	1.3%
8	4532	43.3%

Value	Count	Frequency (%)
8	4532	43.3%
7	132	1.3%
6	2868	27.4%
5	968	9.3%
4	321	3.1%
3	311	3.0%
2	739	7.1%

NumTotalTrades
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	87
Distinct (%)	0.9%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	22.635498

Minimum	0
Maximum	104
Zeros	133
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	13
median	21
Q3	30
95-th percentile	46
Maximum	104
Range	104
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.999924
Coefficient of variation (CV)	0.5743158
Kurtosis	1.4920758
Mean	22.635498
Median Absolute Deviation (MAD)	8
Skewness	0.93400304
Sum	223435
Variance	168.99803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	358	3.4%
16	354	3.4%
17	350	3.3%
22	334	3.2%
20	330	3.2%
24	327	3.1%
21	321	3.1%
19	312	3.0%
18	312	3.0%
13	312	3.0%
Other values (77)	6561	62.7%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	133	1.3%
1	45	0.4%
2	76	0.7%
3	115	1.1%
4	119	1.1%
5	132	1.3%
6	147	1.4%
7	190	1.8%
8	186	1.8%
9	238	2.3%

Value	Count	Frequency (%)
104	1	< 0.1%
100	1	< 0.1%
87	1	< 0.1%
86	1	< 0.1%
85	1	< 0.1%
84	1	< 0.1%
83	3	< 0.1%
82	2	< 0.1%
79	2	< 0.1%
78	2	< 0.1%

NumTradesOpeninLast12M
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	18
Distinct (%)	0.2%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.8638436

Minimum	0
Maximum	19
Zeros	2508
Zeros (%)	24.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	5
Maximum	19
Range	19
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.828099
Coefficient of variation (CV)	0.9808221
Kurtosis	4.2669898
Mean	1.8638436
Median Absolute Deviation (MAD)	1
Skewness	1.5432729
Sum	18398
Variance	3.3419459
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
1	2528	24.2%
0	2508	24.0%
2	1969	18.8%
3	1302	12.4%
4	744	7.1%
5	365	3.5%
6	229	2.2%
7	108	1.0%
8	56	0.5%
9	25	0.2%
Other values (8)	37	0.4%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2508	24.0%
1	2528	24.2%
2	1969	18.8%
3	1302	12.4%
4	744	7.1%
5	365	3.5%
6	229	2.2%
7	108	1.0%
8	56	0.5%
9	25	0.2%

Value	Count	Frequency (%)
19	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	2	< 0.1%
12	4	< 0.1%
11	8	0.1%
10	18	0.2%
9	25	0.2%
8	56	0.5%

PercentInstallTrades
Real number (ℝ)

MISSING ZEROS

Distinct	95
Distinct (%)	1.0%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	34.618681

Minimum	0
Maximum	100
Zeros	193
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	21
median	33
Q3	45
95-th percentile	67
Maximum	100
Range	100
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	17.953432
Coefficient of variation (CV)	0.5186053
Kurtosis	0.71176784
Mean	34.618681
Median Absolute Deviation (MAD)	12
Skewness	0.68207952
Sum	341721
Variance	322.32571
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	449	4.3%
50	417	4.0%
29	334	3.2%
25	321	3.1%
38	274	2.6%
20	273	2.6%
36	247	2.4%
40	242	2.3%
27	226	2.2%
17	225	2.2%
Other values (85)	6863	65.6%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	193	1.8%
2	1	< 0.1%
3	12	0.1%
4	29	0.3%
5	31	0.3%
6	36	0.3%
7	57	0.5%
8	77	0.7%
9	83	0.8%
10	84	0.8%

Value	Count	Frequency (%)
100	76	0.7%
94	1	< 0.1%
93	1	< 0.1%
92	2	< 0.1%
91	3	< 0.1%
90	5	< 0.1%
89	4	< 0.1%
88	5	< 0.1%
87	3	< 0.1%
86	12	0.1%

MSinceMostRecentInqexcl7days
Real number (ℝ)

MISSING ZEROS

Distinct	25
Distinct (%)	0.3%
Missing	2919
Missing (%)	27.9%
Infinite	0
Infinite (%)	0.0%
Mean	2.4777188

Minimum	0
Maximum	24
Zeros	4582
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	14
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	4.7604125
Coefficient of variation (CV)	1.9212884
Kurtosis	5.4382691
Mean	2.4777188
Median Absolute Deviation (MAD)	0
Skewness	2.4018969
Sum	18682
Variance	22.661528
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	4582	43.8%
1	614	5.9%
2	378	3.6%
3	309	3.0%
4	268	2.6%
5	191	1.8%
6	150	1.4%
7	139	1.3%
8	112	1.1%
9	99	0.9%
Other values (15)	698	6.7%
(Missing)	2919	27.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4582	43.8%
1	614	5.9%
2	378	3.6%
3	309	3.0%
4	268	2.6%
5	191	1.8%
6	150	1.4%
7	139	1.3%
8	112	1.1%
9	99	0.9%

Value	Count	Frequency (%)
24	8	0.1%
23	32	0.3%
22	35	0.3%
21	32	0.3%
20	31	0.3%
19	45	0.4%
18	34	0.3%
17	42	0.4%
16	49	0.5%
15	45	0.4%

NumInqLast6M
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	26
Distinct (%)	0.3%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.4559822

Minimum	0
Maximum	66
Zeros	3924
Zeros (%)	37.5%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	66
Range	66
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.136161
Coefficient of variation (CV)	1.4671615
Kurtosis	116.14005
Mean	1.4559822
Median Absolute Deviation (MAD)	1
Skewness	6.1558491
Sum	14372
Variance	4.5631838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	3924	37.5%
1	2545	24.3%
2	1510	14.4%
3	761	7.3%
4	490	4.7%
5	242	2.3%
6	140	1.3%
7	81	0.8%
8	61	0.6%
9	32	0.3%
Other values (16)	85	0.8%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3924	37.5%
1	2545	24.3%
2	1510	14.4%
3	761	7.3%
4	490	4.7%
5	242	2.3%
6	140	1.3%
7	81	0.8%
8	61	0.6%
9	32	0.3%

Value	Count	Frequency (%)
66	1	< 0.1%
46	1	< 0.1%
29	1	< 0.1%
24	2	< 0.1%
21	1	< 0.1%
20	1	< 0.1%
19	3	< 0.1%
18	1	< 0.1%
17	3	< 0.1%
16	4	< 0.1%

NumInqLast6Mexcl7days
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	26
Distinct (%)	0.3%
Missing	588
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.3971229

Minimum	0
Maximum	66
Zeros	4078
Zeros (%)	39.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	66
Range	66
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.0961024
Coefficient of variation (CV)	1.5002992
Kurtosis	125.28391
Mean	1.3971229
Median Absolute Deviation (MAD)	1
Skewness	6.4162635
Sum	13791
Variance	4.3936452
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	4078	39.0%
1	2529	24.2%
2	1450	13.9%
3	759	7.3%
4	454	4.3%
5	232	2.2%
6	132	1.3%
7	71	0.7%
8	59	0.6%
9	28	0.3%
Other values (16)	79	0.8%
(Missing)	588	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4078	39.0%
1	2529	24.2%
2	1450	13.9%
3	759	7.3%
4	454	4.3%
5	232	2.2%
6	132	1.3%
7	71	0.7%
8	59	0.6%
9	28	0.3%

Value	Count	Frequency (%)
66	1	< 0.1%
46	1	< 0.1%
29	1	< 0.1%
24	2	< 0.1%
21	1	< 0.1%
20	1	< 0.1%
19	2	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
16	4	< 0.1%

NetFractionRevolvingBurden
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	126
Distinct (%)	1.3%
Missing	774
Missing (%)	7.4%
Infinite	0
Infinite (%)	0.0%
Mean	34.857718

Minimum	0
Maximum	232
Zeros	608
Zeros (%)	5.8%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	9
median	29
Q3	56
95-th percentile	89
Maximum	232
Range	232
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	28.896627
Coefficient of variation (CV)	0.82898792
Kurtosis	-0.47530642
Mean	34.857718
Median Absolute Deviation (MAD)	23
Skewness	0.62439397
Sum	337597
Variance	835.01507
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	608	5.8%
1	303	2.9%
2	274	2.6%
3	259	2.5%
4	225	2.2%
5	208	2.0%
6	198	1.9%
8	166	1.6%
9	151	1.4%
7	150	1.4%
Other values (116)	7143	68.3%
(Missing)	774	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	608	5.8%
1	303	2.9%
2	274	2.6%
3	259	2.5%
4	225	2.2%
5	208	2.0%
6	198	1.9%
7	150	1.4%
8	166	1.6%
9	151	1.4%

Value	Count	Frequency (%)
232	1	< 0.1%
165	1	< 0.1%
154	1	< 0.1%
135	1	< 0.1%
131	1	< 0.1%
126	1	< 0.1%
124	1	< 0.1%
120	2	< 0.1%
118	2	< 0.1%
117	1	< 0.1%

NetFractionInstallBurden
Real number (ℝ)

MISSING

Distinct	137
Distinct (%)	2.1%
Missing	4007
Missing (%)	38.3%
Infinite	0
Infinite (%)	0.0%
Mean	68.537973

Minimum	0
Maximum	471
Zeros	10
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	19
Q1	53
median	74
Q3	87
95-th percentile	99
Maximum	471
Range	471
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	24.903776
Coefficient of variation (CV)	0.36335735
Kurtosis	10.537817
Mean	68.537973
Median Absolute Deviation (MAD)	16
Skewness	0.01690534
Sum	442207
Variance	620.19806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	174	1.7%
92	144	1.4%
83	134	1.3%
77	133	1.3%
87	130	1.2%
75	128	1.2%
95	126	1.2%
89	125	1.2%
90	124	1.2%
91	122	1.2%
Other values (127)	5112	48.9%
(Missing)	4007	38.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	0.1%
1	4	< 0.1%
2	15	0.1%
3	21	0.2%
4	11	0.1%
5	17	0.2%
6	24	0.2%
7	5	< 0.1%
8	18	0.2%
9	15	0.1%

Value	Count	Frequency (%)
471	1	< 0.1%
196	1	< 0.1%
190	1	< 0.1%
165	1	< 0.1%
153	1	< 0.1%
152	1	< 0.1%
151	1	< 0.1%
144	1	< 0.1%
142	1	< 0.1%
140	1	< 0.1%

NumRevolvingTradesWBalance
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	29
Distinct (%)	0.3%
Missing	744
Missing (%)	7.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.1021101

Minimum	0
Maximum	32
Zeros	304
Zeros (%)	2.9%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	10
Maximum	32
Range	32
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.0216211
Coefficient of variation (CV)	0.73660166
Kurtosis	5.2421079
Mean	4.1021101
Median Absolute Deviation (MAD)	2
Skewness	1.6924021
Sum	39852
Variance	9.1301942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2	1708	16.3%
3	1608	15.4%
4	1361	13.0%
1	1331	12.7%
5	1010	9.7%
6	744	7.1%
7	507	4.8%
8	350	3.3%
0	304	2.9%
9	242	2.3%
Other values (19)	550	5.3%
(Missing)	744	7.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	304	2.9%
1	1331	12.7%
2	1708	16.3%
3	1608	15.4%
4	1361	13.0%
5	1010	9.7%
6	744	7.1%
7	507	4.8%
8	350	3.3%
9	242	2.3%

Value	Count	Frequency (%)
32	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
26	1	< 0.1%
25	1	< 0.1%
24	3	< 0.1%
23	1	< 0.1%
21	5	< 0.1%
20	4	< 0.1%
19	4	< 0.1%

NumInstallTradesWBalance
Real number (ℝ)

MISSING

Distinct	18
Distinct (%)	0.2%
Missing	1449
Missing (%)	13.9%
Infinite	0
Infinite (%)	0.0%
Mean	2.4849057

Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	23
Range	22
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6345031
Coefficient of variation (CV)	0.65777269
Kurtosis	12.173704
Mean	2.4849057
Median Absolute Deviation (MAD)	1
Skewness	2.4608676
Sum	22389
Variance	2.6716003
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
2	2863	27.4%
1	2648	25.3%
3	1809	17.3%
4	922	8.8%
5	352	3.4%
6	186	1.8%
7	86	0.8%
8	49	0.5%
9	36	0.3%
10	18	0.2%
Other values (8)	41	0.4%
(Missing)	1449	13.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2648	25.3%
2	2863	27.4%
3	1809	17.3%
4	922	8.8%
5	352	3.4%
6	186	1.8%
7	86	0.8%
8	49	0.5%
9	36	0.3%
10	18	0.2%

Value	Count	Frequency (%)
23	1	< 0.1%
19	2	< 0.1%
16	1	< 0.1%
15	1	< 0.1%
14	6	0.1%
13	5	< 0.1%
12	10	0.1%
11	15	0.1%
10	18	0.2%
9	36	0.3%

NumBank/NatlTradesWHighUtilization
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	17
Distinct (%)	0.2%
Missing	1171
Missing (%)	11.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.0922696

Minimum	0
Maximum	18
Zeros	4308
Zeros (%)	41.2%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	18
Range	18
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5362504
Coefficient of variation (CV)	1.4064754
Kurtosis	10.936442
Mean	1.0922696
Median Absolute Deviation (MAD)	1
Skewness	2.5635752
Sum	10145
Variance	2.3600651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	4308	41.2%
1	2514	24.0%
2	1222	11.7%
3	620	5.9%
4	280	2.7%
5	154	1.5%
6	81	0.8%
7	38	0.4%
8	30	0.3%
9	11	0.1%
Other values (7)	30	0.3%
(Missing)	1171	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4308	41.2%
1	2514	24.0%
2	1222	11.7%
3	620	5.9%
4	280	2.7%
5	154	1.5%
6	81	0.8%
7	38	0.4%
8	30	0.3%
9	11	0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
16	1	< 0.1%
15	1	< 0.1%
13	3	< 0.1%
12	4	< 0.1%
11	10	0.1%
10	10	0.1%
9	11	0.1%
8	30	0.3%
7	38	0.4%

PercentTradesWBalance
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	93
Distinct (%)	0.9%
Missing	606
Missing (%)	5.8%
Infinite	0
Infinite (%)	0.0%
Mean	66.449

Minimum	0
Maximum	100
Zeros	45
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	81.8 KiB

Quantile statistics

Minimum	0
5-th percentile	29
Q1	50
median	67
Q3	83
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	22.035459
Coefficient of variation (CV)	0.33161461
Kurtosis	-0.52748621
Mean	66.449
Median Absolute Deviation (MAD)	17
Skewness	-0.26919965
Sum	654722
Variance	485.56147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	1277	12.2%
50	733	7.0%
67	611	5.8%
75	535	5.1%
80	374	3.6%
60	342	3.3%
83	316	3.0%
71	281	2.7%
33	273	2.6%
57	245	2.3%
Other values (83)	4866	46.5%
(Missing)	606	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	45	0.4%
4	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	3	< 0.1%
9	2	< 0.1%
10	6	0.1%
11	8	0.1%
12	3	< 0.1%
13	15	0.1%

Value	Count	Frequency (%)
100	1277	12.2%
96	3	< 0.1%
95	13	0.1%
94	28	0.3%
93	37	0.4%
92	82	0.8%
91	82	0.8%
90	93	0.9%
89	138	1.3%
88	176	1.7%

Auto

Heatmap
Table

	AverageMInFile	ExternalRiskEstimate	MSinceMostRecentDelq	MSinceMostRecentInqexcl7days	MSinceMostRecentTradeOpen	MSinceOldestTradeOpen	MaxDelq/PublicRecLast12M	MaxDelqEver	NetFractionInstallBurden	NetFractionRevolvingBurden	NumBank/NatlTradesWHighUtilization	NumInqLast6M	NumInqLast6Mexcl7days	NumInstallTradesWBalance	NumRevolvingTradesWBalance	NumSatisfactoryTrades	NumTotalTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	NumTradesOpeninLast12M	PercentInstallTrades	PercentTradesNeverDelq	PercentTradesWBalance	RiskPerformance
AverageMInFile	1.000	0.330	-0.014	0.128	0.292	0.724	-0.028	-0.047	-0.185	-0.209	-0.112	-0.199	-0.195	-0.136	-0.000	0.172	0.140	0.013	-0.012	-0.369	-0.171	-0.044	-0.209	0.250
ExternalRiskEstimate	0.330	1.000	0.523	0.198	0.133	0.252	0.619	0.531	-0.060	-0.640	-0.559	-0.228	-0.229	-0.194	-0.358	0.019	-0.026	-0.483	-0.416	-0.184	-0.159	0.586	-0.454	0.462
MSinceMostRecentDelq	-0.014	0.523	1.000	0.052	-0.084	-0.006	0.783	0.021	0.071	-0.083	-0.075	0.018	0.017	-0.055	-0.081	-0.002	-0.015	-0.031	0.003	0.078	-0.011	0.307	-0.064	0.199
MSinceMostRecentInqexcl7days	0.128	0.198	0.052	1.000	0.033	0.108	0.092	0.086	-0.041	-0.138	-0.122	-0.273	-0.275	-0.013	-0.041	0.092	0.062	-0.089	-0.086	-0.030	-0.044	0.110	-0.102	0.202
MSinceMostRecentTradeOpen	0.292	0.133	-0.084	0.033	1.000	0.089	-0.009	-0.003	-0.249	-0.052	-0.102	-0.334	-0.341	-0.211	-0.211	-0.232	-0.228	0.024	0.013	-0.755	-0.005	-0.054	0.015	0.000
MSinceOldestTradeOpen	0.724	0.252	-0.006	0.108	0.089	1.000	-0.019	-0.019	-0.116	-0.169	-0.044	-0.106	-0.103	-0.020	0.118	0.280	0.314	-0.027	-0.045	-0.113	-0.172	0.003	-0.221	0.220
MaxDelq/PublicRecLast12M	-0.028	0.619	0.783	0.092	-0.009	-0.019	1.000	0.822	0.025	-0.184	-0.127	-0.048	-0.052	-0.109	-0.116	-0.034	-0.077	-0.538	-0.424	0.006	-0.115	0.830	-0.142	0.275
MaxDelqEver	-0.047	0.531	0.021	0.086	-0.003	-0.019	0.822	1.000	0.015	-0.155	-0.091	-0.042	-0.043	-0.078	-0.055	0.011	-0.052	-0.684	-0.519	0.014	-0.118	0.902	-0.124	0.236
NetFractionInstallBurden	-0.185	-0.060	0.071	-0.041	-0.249	-0.116	0.025	0.015	1.000	0.041	0.021	0.101	0.100	-0.007	-0.017	-0.034	-0.022	-0.010	-0.007	0.274	0.081	0.026	0.053	0.048
NetFractionRevolvingBurden	-0.209	-0.640	-0.083	-0.138	-0.052	-0.169	-0.184	-0.155	0.041	1.000	0.700	0.097	0.098	0.137	0.411	-0.036	-0.018	0.122	0.094	0.078	0.132	-0.194	0.613	0.349
NumBank/NatlTradesWHighUtilization	-0.112	-0.559	-0.075	-0.122	-0.102	-0.044	-0.127	-0.091	0.021	0.700	1.000	0.127	0.127	0.140	0.542	0.193	0.169	0.030	0.011	0.127	-0.028	-0.104	0.362	0.221
NumInqLast6M	-0.199	-0.228	0.018	-0.273	-0.334	-0.106	-0.048	-0.042	0.101	0.097	0.127	1.000	0.982	0.125	0.107	0.112	0.117	0.049	0.055	0.302	0.039	-0.023	0.046	0.080
NumInqLast6Mexcl7days	-0.195	-0.229	0.017	-0.275	-0.341	-0.103	-0.052	-0.043	0.100	0.098	0.127	0.982	1.000	0.127	0.112	0.116	0.123	0.048	0.055	0.304	0.038	-0.023	0.046	0.077
NumInstallTradesWBalance	-0.136	-0.194	-0.055	-0.013	-0.211	-0.020	-0.109	-0.078	-0.007	0.137	0.140	0.125	0.127	1.000	0.160	0.341	0.309	0.024	0.012	0.275	0.369	-0.033	0.220	0.055
NumRevolvingTradesWBalance	-0.000	-0.358	-0.081	-0.041	-0.211	0.118	-0.116	-0.055	-0.017	0.411	0.542	0.107	0.112	0.160	1.000	0.479	0.410	-0.028	-0.045	0.270	-0.248	-0.019	0.287	0.133
NumSatisfactoryTrades	0.172	0.019	-0.002	0.092	-0.232	0.280	-0.034	0.011	-0.034	-0.036	0.193	0.112	0.116	0.341	0.479	1.000	0.859	-0.139	-0.137	0.305	-0.115	0.127	-0.252	0.157
NumTotalTrades	0.140	-0.026	-0.015	0.062	-0.228	0.314	-0.077	-0.052	-0.022	-0.018	0.169	0.117	0.123	0.309	0.410	0.859	1.000	-0.052	-0.065	0.280	-0.064	0.051	-0.200	0.107
NumTrades60Ever/DerogPubRec	0.013	-0.483	-0.031	-0.089	0.024	-0.027	-0.538	-0.684	-0.010	0.122	0.030	0.049	0.048	0.024	-0.028	-0.139	-0.052	1.000	0.832	-0.039	0.123	-0.572	0.142	0.154
NumTrades90Ever/DerogPubRec	-0.012	-0.416	0.003	-0.086	0.013	-0.045	-0.424	-0.519	-0.007	0.094	0.011	0.055	0.055	0.012	-0.045	-0.137	-0.065	0.832	1.000	-0.029	0.108	-0.406	0.124	0.124
NumTradesOpeninLast12M	-0.369	-0.184	0.078	-0.030	-0.755	-0.113	0.006	0.014	0.274	0.078	0.127	0.302	0.304	0.275	0.270	0.305	0.280	-0.039	-0.029	1.000	0.006	0.075	-0.007	0.074
PercentInstallTrades	-0.171	-0.159	-0.011	-0.044	-0.005	-0.172	-0.115	-0.118	0.081	0.132	-0.028	0.039	0.038	0.369	-0.248	-0.115	-0.064	0.123	0.108	0.006	1.000	-0.131	0.405	0.148
PercentTradesNeverDelq	-0.044	0.586	0.307	0.110	-0.054	0.003	0.830	0.902	0.026	-0.194	-0.104	-0.023	-0.023	-0.033	-0.019	0.127	0.051	-0.572	-0.406	0.075	-0.131	1.000	-0.174	0.258
PercentTradesWBalance	-0.209	-0.454	-0.064	-0.102	0.015	-0.221	-0.142	-0.124	0.053	0.613	0.362	0.046	0.046	0.220	0.287	-0.252	-0.200	0.142	0.124	-0.007	0.405	-0.174	1.000	0.281
RiskPerformance	0.250	0.462	0.199	0.202	0.000	0.220	0.275	0.236	0.048	0.349	0.221	0.080	0.077	0.055	0.133	0.157	0.107	0.154	0.124	0.074	0.148	0.258	0.281	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	RiskPerformance	ExternalRiskEstimate	MSinceOldestTradeOpen	MSinceMostRecentTradeOpen	AverageMInFile	NumSatisfactoryTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	PercentTradesNeverDelq	MSinceMostRecentDelq	MaxDelq/PublicRecLast12M	MaxDelqEver	NumTotalTrades	NumTradesOpeninLast12M	PercentInstallTrades	NumInqLast6M	NumInqLast6Mexcl7days	NetFractionRevolvingBurden	NetFractionInstallBurden	NumRevolvingTradesWBalance	NumInstallTradesWBalance	NumBank/NatlTradesWHighUtilization	PercentTradesWBalance
0	Bad	55.0	144.0	4.0	84.0	20.0	3.0	0.0	83.0	2.0	3.0	5.0	23.0	1.0	43.0	0.0	0.0	33.0	NaN	8.0	1.0	1.0	69.0
1	Bad	61.0	58.0	15.0	41.0	2.0	4.0	4.0	100.0	NaN	0.0	8.0	7.0	0.0	67.0	0.0	0.0	0.0	NaN	0.0	NaN	NaN	0.0
2	Bad	67.0	66.0	5.0	24.0	9.0	0.0	0.0	100.0	NaN	7.0	8.0	9.0	4.0	44.0	4.0	4.0	53.0	66.0	4.0	2.0	1.0	86.0
3	Bad	66.0	169.0	1.0	73.0	28.0	1.0	1.0	93.0	76.0	6.0	6.0	30.0	3.0	57.0	5.0	4.0	72.0	83.0	6.0	4.0	3.0	91.0
4	Bad	81.0	333.0	27.0	132.0	12.0	0.0	0.0	100.0	NaN	7.0	8.0	12.0	0.0	25.0	1.0	1.0	51.0	89.0	3.0	1.0	0.0	80.0
5	Bad	59.0	137.0	11.0	78.0	31.0	0.0	0.0	91.0	1.0	4.0	6.0	32.0	1.0	47.0	0.0	0.0	62.0	93.0	12.0	4.0	3.0	94.0
6	Good	54.0	88.0	7.0	37.0	25.0	0.0	0.0	92.0	9.0	4.0	6.0	26.0	3.0	58.0	4.0	4.0	89.0	76.0	7.0	7.0	2.0	100.0
7	Good	68.0	148.0	7.0	65.0	17.0	0.0	0.0	83.0	31.0	6.0	6.0	18.0	1.0	44.0	0.0	0.0	28.0	48.0	2.0	2.0	2.0	40.0
8	Bad	59.0	324.0	2.0	138.0	24.0	0.0	0.0	85.0	5.0	4.0	6.0	27.0	1.0	26.0	1.0	1.0	68.0	NaN	7.0	1.0	3.0	90.0
9	Bad	61.0	79.0	4.0	36.0	19.0	0.0	0.0	95.0	5.0	4.0	6.0	19.0	3.0	26.0	6.0	6.0	31.0	86.0	5.0	3.0	1.0	62.0

	RiskPerformance	ExternalRiskEstimate	MSinceOldestTradeOpen	MSinceMostRecentTradeOpen	AverageMInFile	NumSatisfactoryTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	PercentTradesNeverDelq	MSinceMostRecentDelq	MaxDelq/PublicRecLast12M	MaxDelqEver	NumTotalTrades	NumTradesOpeninLast12M	PercentInstallTrades	MSinceMostRecentInqexcl7days	NumInqLast6M	NumInqLast6Mexcl7days	NetFractionRevolvingBurden	NetFractionInstallBurden	NumRevolvingTradesWBalance	NumInstallTradesWBalance	NumBank/NatlTradesWHighUtilization	PercentTradesWBalance
10449	Good	57.0	176.0	4.0	87.0	18.0	0.0	0.0	89.0	2.0	4.0	6.0	18.0	1.0	56.0	4.0	1.0	1.0	93.0	72.0	5.0	3.0	1.0	100.0
10450	Good	84.0	313.0	6.0	103.0	25.0	0.0	0.0	100.0	NaN	7.0	8.0	25.0	2.0	24.0	11.0	0.0	0.0	10.0	92.0	4.0	3.0	0.0	70.0
10451	Good	79.0	133.0	2.0	68.0	27.0	0.0	0.0	100.0	NaN	7.0	8.0	30.0	3.0	36.0	0.0	4.0	4.0	1.0	93.0	4.0	2.0	0.0	60.0
10452	Good	90.0	197.0	5.0	92.0	13.0	0.0	0.0	100.0	NaN	7.0	8.0	13.0	1.0	46.0	4.0	2.0	2.0	5.0	50.0	3.0	3.0	0.0	100.0
10453	Bad	75.0	410.0	2.0	121.0	37.0	1.0	1.0	83.0	10.0	4.0	3.0	43.0	1.0	7.0	1.0	1.0	1.0	34.0	NaN	7.0	1.0	1.0	53.0
10454	Good	73.0	131.0	5.0	57.0	21.0	0.0	0.0	95.0	80.0	6.0	6.0	21.0	5.0	19.0	7.0	0.0	0.0	26.0	NaN	5.0	2.0	0.0	100.0
10455	Bad	65.0	147.0	39.0	68.0	11.0	0.0	0.0	92.0	28.0	6.0	6.0	12.0	0.0	42.0	1.0	1.0	1.0	86.0	53.0	2.0	2.0	1.0	80.0
10456	Bad	74.0	129.0	6.0	64.0	18.0	1.0	1.0	100.0	NaN	6.0	8.0	18.0	1.0	33.0	3.0	4.0	4.0	6.0	NaN	5.0	NaN	0.0	56.0
10457	Bad	72.0	234.0	12.0	113.0	42.0	2.0	2.0	96.0	35.0	6.0	2.0	45.0	0.0	20.0	6.0	0.0	0.0	19.0	NaN	4.0	1.0	0.0	38.0
10458	Bad	66.0	28.0	1.0	17.0	4.0	0.0	0.0	100.0	NaN	7.0	8.0	5.0	2.0	60.0	3.0	3.0	2.0	67.0	NaN	2.0	1.0	0.0	100.0

Most frequently occurring

	RiskPerformance	ExternalRiskEstimate	MSinceOldestTradeOpen	MSinceMostRecentTradeOpen	AverageMInFile	NumSatisfactoryTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	PercentTradesNeverDelq	MSinceMostRecentDelq	MaxDelq/PublicRecLast12M	MaxDelqEver	NumTotalTrades	NumTradesOpeninLast12M	PercentInstallTrades	MSinceMostRecentInqexcl7days	NumInqLast6M	NumInqLast6Mexcl7days	NetFractionRevolvingBurden	NetFractionInstallBurden	NumRevolvingTradesWBalance	NumInstallTradesWBalance	NumBank/NatlTradesWHighUtilization	PercentTradesWBalance	# duplicates
1	Bad	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	323
2	Good	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	265
0	Bad	64.0	242.0	18.0	124.0	16.0	2.0	0.0	47.0	2.0	4.0	5.0	19.0	0.0	74.0	0.0	4.0	4.0	27.0	NaN	2.0	3.0	0.0	100.0	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring